Token Formatting--Empty Tokens

You can format a token so that when you create the token with a blank value (or an empty string), the blank value is replaced with "NULL," instead of remaining blank. Do this by including the string "NULL" in the token format, as in %(TokenName#"NULL"#).

Example: Formatting using NULL in an empty token:

Input Test: 45
Input Value: %(Entry Name#"NULL"#)
Output Test: 45
Output Value: NULL

Note: %(TokenName#"NULL"#) either inserts the value "null" if the token value is blank or inserts a specific value if the token value is not blank. You would use %(DB.NULL) if you want to insert "null" into the database in any circumstance, whether the token value is blank or not.